package com.liqi.display.mapper;

import com.liqi.display.entity.returnType.TopEightTask;
import com.liqi.display.entity.UpProAccept;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Param;

import java.util.Date;
import java.util.List;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author liqi
 * @since 2021-04-12
 */
public interface UpProAcceptMapper extends BaseMapper<UpProAccept> {

    List<UpProAccept> selectAll();

    int total(Date date);

    List<TopEightTask> topEightTask(Date date);

    List<UpProAccept> getList(Date date);

    int lateThirty(@Param("start")Date start,@Param("end")Date end);

    List<TopEightTask>  totalAcceptType(Date date);

    List<TopEightTask> totalBidType(Date date);

    List<TopEightTask> specilAcceptTotal(Date date);

    /**
     * 获取本年度汕尾各县市区办件受理量
     * @param date
     * @return
     */
    int totalRegionNums(@Param("date") Date date,@Param("regionCode") String regionCode);

    int areaApplyTotal(@Param("date") Date date,@Param("areaTag") String areaTag);

    /**
     * 近7天窗口申办量排名折线图　
     * @param date
     * @return
     */
    List<TopEightTask> windowBusinessTopNum(Date date);
    
    
    /**
     * 获取平均受理时间
     * @param date
     * @return
     */
    double getAccessTime(Date date);
}
